
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for base_dict
-- ----------------------------
DROP TABLE IF EXISTS `base_dict`;
CREATE TABLE `base_dict`  (
  `dict_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '数据字典id',
  `dict_type_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据字典类别代码',
  `dict_type_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数组字典类别名称',
  `dict_item_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '数据字典项目名称',
  `dict_item_code` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '数据字典项目代码',
  `dict_sort` int(10) NOT NULL COMMENT '排序字段',
  `dict_enable` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '是否可用',
  `dict_memo` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of base_dict
-- ----------------------------
BEGIN;
INSERT INTO `base_dict` VALUES ('0001', '002', '客户来源', '电话推销', '', 1, '1', 'asd'), ('0002', '002', '客户来源', '短信推销', '', 1, '1', 'asd'), ('0003', '002', '客户来源', 'QQ推销', NULL, 1, '1', 'aaa'), ('0004', '002', '客户来源', '微信推销', NULL, 1, '1', 'aaa'), ('0005', '001', '客户所属行业', '食品 ', NULL, 1, '1', 'sss'), ('0006', '001', '客户所属行业', '汽车', NULL, 1, '1', 'sss'), ('0007', '001', '客户所属行业', '电子商务', '', 1, '1', 'asd'), ('0008', '001', '客户所属行业', '酒店旅游', '', 1, '1', 'asd'), ('0009', '006', '客户级别', 'VIP客户', '', 1, '1', 'asd'), ('0010', '006', '客户级别', '普通客户', '', 1, '1', 'asd');
COMMIT;

-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer`  (
  `cust_id` int(32) NOT NULL AUTO_INCREMENT,
  `cust_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户名称',
  `cust_user_id` int(32) NOT NULL COMMENT '负责人id',
  `cust_create_id` int(32) NOT NULL COMMENT '创建人id',
  `cust_source` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户信息来源',
  `cust_industry` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户所属产业',
  `cust_level` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '客户级别',
  `cust_linkman` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系人',
  `cust_phone` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '固定电话',
  `cust_mobile` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '移动电话',
  `cust_zipcode` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮政编码',
  `cust_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '联系地址',
  `cust_createtime` datetime(0) NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`cust_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 101 CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of customer
-- ----------------------------
BEGIN;
INSERT INTO `customer` VALUES (1, '周八', 1, 1, '0001', '0007', '0009', '周八', '13033885505', '13033885505', '511525', '云南省楚雄彝族自治州南华县', '2018-06-25 11:54:39'), (2, '陈二', 1, 1, '0003', '0008', '0010', '陈二', '18346439044', '18346439044', '320481', '西藏自治区那曲地区申扎县', '2018-06-25 15:16:11'), (3, '张三', 1, 1, '0001', '0007', '0010', '张三', '18775242401', '18775242401', '350303', '山西省晋中地区寿阳县', '2018-06-25 19:48:12'), (4, '王五', 1, 1, '0003', '0008', '0010', '王五', '15144964070', '15144964070', '410401', '河南省郑州市市辖区', '2018-06-25 20:04:17'), (5, '孙七', 1, 1, '0001', '0006', '0010', '孙七', '18629661055', '18629661055', '411102', '山东省德州市宁津县', '2018-06-25 16:59:55'), (6, '张三', 1, 1, '0001', '0007', '0009', '张三', '18458886826', '18458886826', '410305', '辽宁省鞍山市铁西区', '2018-06-25 15:13:01'), (7, '刘一', 1, 1, '0002', '0005', '0010', '刘一', '15427190105', '15427190105', '513338', '浙江省嘉兴市海盐县', '2018-06-25 18:50:07'), (8, '赵六', 1, 1, '0004', '0005', '0010', '赵六', '17554759613', '17554759613', '441801', '四川省绵阳市三台县', '2018-06-25 12:51:15'), (9, '吴九', 1, 1, '0004', '0006', '0010', '吴九', '15646461299', '15646461299', '350103', '山东省德州市市辖区', '2018-06-25 13:38:24'), (10, '陈二', 1, 1, '0004', '0008', '0010', '陈二', '17111805936', '17111805936', '350430', '安徽省淮南市凤台县', '2018-06-25 17:32:12'), (11, '刘一', 1, 1, '0002', '0008', '0010', '刘一', '15850471860', '15850471860', '152625', '上海市', '2018-06-25 16:44:16'), (12, '王五', 1, 1, '0001', '0008', '0009', '王五', '15139207841', '15139207841', '131026', '四川省泸州市纳溪区', '2018-06-25 14:32:51'), (13, '张三', 1, 1, '0002', '0006', '0010', '张三', '17572736889', '17572736889', '210103', '安徽省宿州市泗县', '2018-06-25 18:08:32'), (14, '吴九', 1, 1, '0001', '0007', '0009', '吴九', '17270557958', '17270557958', '450103', '海南省三亚市乐东黎族自治县', '2018-06-25 19:46:56'), (15, '李四', 1, 1, '0003', '0007', '0010', '李四', '15319291953', '15319291953', '210103', '湖南省郴州市嘉禾县', '2018-06-25 18:59:10'), (16, '吴九', 1, 1, '0003', '0006', '0010', '吴九', '13933299542', '13933299542', '522634', '河北省承德市宽城满族自治县', '2018-06-25 13:38:46'), (17, '刘一', 1, 1, '0003', '0008', '0009', '刘一', '13380603789', '13380603789', '522630', '河北省邯郸市广平县', '2018-06-25 13:18:02'), (18, '赵六', 1, 1, '0002', '0007', '0010', '赵六', '17853686630', '17853686630', '152525', '黑龙江省伊春市上甘岭区', '2018-06-25 17:02:55'), (19, '赵六', 1, 1, '0004', '0005', '0009', '赵六', '17826077957', '17826077957', '542422', '四川省乐山市犍为县', '2018-06-25 17:34:49'), (20, '周八', 1, 1, '0002', '0006', '0009', '周八', '15281893845', '15281893845', '622424', '福建省福州市长乐市', '2018-06-25 13:50:04'), (21, '王五', 1, 1, '0004', '0006', '0010', '王五', '13165640128', '13165640128', '142630', '黑龙江省七台河市', '2018-06-25 15:31:52'), (22, '吴九', 1, 1, '0002', '0007', '0009', '吴九', '18235500563', '18235500563', '620302', '湖北省孝感市市辖区', '2018-06-25 15:06:11'), (23, '陈二', 1, 1, '0004', '0007', '0010', '陈二', '15429953338', '15429953338', '640111', '湖南省邵阳市大祥区', '2018-06-25 20:12:49'), (24, '孙七', 1, 1, '0002', '0008', '0009', '孙七', '13360410908', '13360410908', '412700', '西藏自治区那曲地区申扎县', '2018-06-25 12:09:43'), (25, '张三', 1, 1, '0003', '0005', '0010', '张三', '13741948420', '13741948420', '542233', '河南省南阳市淅川县', '2018-06-25 16:41:33'), (26, '王五', 1, 1, '0003', '0008', '0009', '王五', '15088816286', '15088816286', '152601', '贵州省铜仁地区玉屏侗族自治县', '2018-06-25 15:59:19'), (27, '张三', 1, 1, '0001', '0008', '0010', '张三', '15202993016', '15202993016', '420702', '山东省淄博市临淄区', '2018-06-25 13:21:47'), (28, '张三', 1, 1, '0002', '0005', '0010', '张三', '17182470201', '17182470201', '420527', '贵州省安顺地区关岭布依族苗族自治县', '2018-06-25 14:25:51'), (29, '李四', 1, 1, '0002', '0005', '0010', '李四', '17619391531', '17619391531', '411201', '云南省德宏傣族景颇族自治州', '2018-06-25 16:08:22'), (30, '陈二', 1, 1, '0004', '0005', '0010', '陈二', '18364105333', '18364105333', '211004', '浙江省丽水地区松阳县', '2018-06-25 17:41:26'), (31, '郑十', 1, 1, '0004', '0006', '0009', '郑十', '15168875911', '15168875911', '320111', '青海省海东地区', '2018-06-25 12:48:57'), (32, '陈二', 1, 1, '0003', '0007', '0009', '陈二', '13064124323', '13064124323', '610621', '四川省绵阳市涪城区', '2018-06-25 18:40:05'), (33, '李四', 1, 1, '0003', '0006', '0010', '李四', '13210584974', '13210584974', '632324', '云南省昆明市五华区', '2018-06-25 19:47:24'), (34, '吴九', 1, 1, '0004', '0008', '0010', '吴九', '15572334848', '15572334848', '432502', '河北省廊坊市固安县', '2018-06-25 12:09:58'), (35, '吴九', 1, 1, '0003', '0006', '0010', '吴九', '18254696147', '18254696147', '320400', '陕西省渭南市富平县', '2018-06-25 17:40:16'), (36, '王五', 1, 1, '0001', '0006', '0010', '王五', '15518455765', '15518455765', '232304', '福建省漳州市平和县', '2018-06-25 18:01:00'), (37, '赵六', 1, 1, '0003', '0008', '0010', '赵六', '15707490183', '15707490183', '310103', '陕西省安康地区安康市', '2018-06-25 15:09:49'), (38, '张三', 1, 1, '0001', '0006', '0010', '张三', '13717148228', '13717148228', '620121', '广东省惠州市惠东县', '2018-06-25 15:56:51'), (39, '王五', 1, 1, '0004', '0006', '0010', '王五', '17028171171', '17028171171', '430104', '安徽省蚌埠市怀远县', '2018-06-25 15:31:15'), (40, '李四', 1, 1, '0001', '0005', '0009', '李四', '17066222084', '17066222084', '232300', '浙江省丽水地区青田县', '2018-06-25 17:53:59'), (41, '李四', 1, 1, '0002', '0008', '0009', '李四', '15460645145', '15460645145', '513826', '贵州省黔东南苗族侗族自治州从江县', '2018-06-25 17:43:21'), (42, '李四', 1, 1, '0002', '0007', '0009', '李四', '17584532755', '17584532755', '370502', '河北省石家庄市元氏县', '2018-06-25 20:03:26'), (43, '张三', 1, 1, '0004', '0007', '0009', '张三', '15667330970', '15667330970', '542526', '辽宁省鞍山市海城市', '2018-06-25 13:02:05'), (44, '吴九', 1, 1, '0002', '0007', '0010', '吴九', '17602984685', '17602984685', '431202', '广东省韶关市北江区', '2018-06-25 17:16:41'), (45, '李四', 1, 1, '0004', '0008', '0009', '李四', '17735412368', '17735412368', '371301', '山西省忻州地区原平市', '2018-06-25 13:32:58'), (46, '赵六', 1, 1, '0001', '0005', '0009', '赵六', '18499651889', '18499651889', '441621', '贵州省铜仁地区德江县', '2018-06-25 17:45:18'), (47, '张三', 1, 1, '0004', '0005', '0010', '张三', '18436777521', '18436777521', '130300', '云南省西双版纳傣族自治州景洪市', '2018-06-25 16:06:31'), (48, '刘一', 1, 1, '0001', '0007', '0009', '刘一', '18896518202', '18896518202', '410601', '吉林省白城市洮南市', '2018-06-25 14:01:11'), (49, '赵六', 1, 1, '0004', '0007', '0010', '赵六', '18799556409', '18799556409', '610425', '安徽省淮北市烈山区', '2018-06-25 16:51:44'), (50, '周八', 1, 1, '0001', '0006', '0009', '周八', '18392044116', '18392044116', '420682', '贵州省贵阳市息烽县', '2018-06-25 14:59:13'), (51, '郑十', 1, 1, '0002', '0005', '0010', '郑十', '17716914565', '17716914565', '350424', '内蒙古自治区呼伦贝尔盟莫力达瓦达斡尔族自治旗', '2018-06-25 15:31:07'), (52, '刘一', 1, 1, '0001', '0007', '0010', '刘一', '18888695100', '18888695100', '130604', '陕西省榆林地区榆林市', '2018-06-25 12:28:36'), (53, '孙七', 1, 1, '0002', '0007', '0009', '孙七', '13382440654', '13382440654', '320114', '广西壮族自治区桂林市临桂县', '2018-06-25 17:05:55'), (54, '李四', 1, 1, '0002', '0008', '0010', '李四', '17235968057', '17235968057', '340504', '山西省晋中地区榆次市', '2018-06-25 18:45:55'), (55, '郑十', 1, 1, '0004', '0006', '0010', '郑十', '17055254754', '17055254754', '445302', '海南省中沙群岛的岛礁及其海域', '2018-06-25 12:35:01'), (56, '孙七', 1, 1, '0001', '0006', '0009', '孙七', '18275221725', '18275221725', '152102', '江苏省苏州市昆山市', '2018-06-25 12:55:56'), (57, '吴九', 1, 1, '0004', '0005', '0010', '吴九', '18013329094', '18013329094', '510123', '广西壮族自治区贺州地区昭平县', '2018-06-25 13:32:44'), (58, '周八', 1, 1, '0002', '0006', '0010', '周八', '13604064953', '13604064953', '522702', '湖南省怀化市', '2018-06-25 13:31:21'), (59, '周八', 1, 1, '0004', '0006', '0009', '周八', '13053179131', '13053179131', '142222', '内蒙古自治区呼和浩特市', '2018-06-25 18:57:35'), (60, '孙七', 1, 1, '0001', '0006', '0010', '孙七', '17269638829', '17269638829', '511124', '新疆维吾尔族自治区阿勒泰地区', '2018-06-25 18:25:00'), (61, '吴九', 1, 1, '0001', '0007', '0009', '吴九', '17651395693', '17651395693', '612726', '河南省漯河市', '2018-06-25 12:41:21'), (62, '孙七', 1, 1, '0002', '0007', '0009', '孙七', '13900329656', '13900329656', '610400', '广西壮族自治区防城港市', '2018-06-25 16:05:19'), (63, '吴九', 1, 1, '0002', '0008', '0009', '吴九', '15664204716', '15664204716', '511525', '重庆市沙坪坝区', '2018-06-25 14:18:11'), (64, '周八', 1, 1, '0001', '0007', '0009', '周八', '18267279107', '18267279107', '441821', '湖南省益阳市资阳区', '2018-06-25 15:45:09'), (65, '孙七', 1, 1, '0004', '0007', '0009', '孙七', '15868628048', '15868628048', '620300', '黑龙江省绥化地区安达市', '2018-06-25 17:10:28'), (66, '李四', 1, 1, '0001', '0006', '0010', '李四', '18618018745', '18618018745', '542132', '黑龙江省伊春市西林区', '2018-06-25 15:20:09'), (67, '陈二', 1, 1, '0003', '0007', '0009', '陈二', '17650566745', '17650566745', '530111', '黑龙江省哈尔滨市阿城市', '2018-06-25 12:08:50'), (68, '赵六', 1, 1, '0002', '0005', '0009', '赵六', '17305505393', '17305505393', '120111', '河北省承德市滦平县', '2018-06-25 18:12:04'), (69, '陈二', 1, 1, '0002', '0007', '0010', '陈二', '17033126062', '17033126062', '130132', '西藏自治区日喀则地区定日县', '2018-06-25 12:41:22'), (70, '张三', 1, 1, '0002', '0008', '0009', '张三', '15911777035', '15911777035', '230800', '河北省保定市涞水县', '2018-06-25 16:17:55'), (71, '吴九', 1, 1, '0003', '0007', '0009', '吴九', '15272153428', '15272153428', '622301', '海南省三亚市定安县', '2018-06-25 19:13:15'), (72, '刘一', 1, 1, '0002', '0008', '0010', '刘一', '13959868807', '13959868807', '320104', '广西壮族自治区桂林市雁山区', '2018-06-25 18:25:04'), (73, '李四', 1, 1, '0001', '0005', '0010', '李四', '15328315615', '15328315615', '610581', '广西壮族自治区柳州市柳北区', '2018-06-25 18:32:05'), (74, '赵六', 1, 1, '0003', '0007', '0010', '赵六', '18459323246', '18459323246', '152600', '四川省德阳市广汉市', '2018-06-25 15:06:47'), (75, '郑十', 1, 1, '0001', '0006', '0010', '郑十', '13707117129', '13707117129', '142730', '湖南省郴州市永兴县', '2018-06-25 18:15:18'), (76, '赵六', 1, 1, '0001', '0005', '0010', '赵六', '17622454272', '17622454272', '510101', '云南省楚雄彝族自治州南华县', '2018-06-25 14:59:22'), (77, '刘一', 1, 1, '0002', '0005', '0009', '刘一', '13652651426', '13652651426', '520382', '云南省红河哈尼族彝族自治州元阳县', '2018-06-25 15:41:11'), (78, '郑十', 1, 1, '0002', '0008', '0010', '郑十', '18160865721', '18160865721', '320704', '海南省三亚市儋州市', '2018-06-25 20:02:15'), (79, '张三', 1, 1, '0001', '0008', '0010', '张三', '13853765676', '13853765676', '513822', '吉林省长春市二道区', '2018-06-25 12:42:36'), (80, '张三', 1, 1, '0004', '0005', '0010', '张三', '13012600547', '13012600547', '510422', '安徽省池州地区石台县', '2018-06-25 12:53:16'), (81, '王五', 1, 1, '0003', '0008', '0010', '王五', '17445548684', '17445548684', '653122', '四川省凉山彝族自治州德昌县', '2018-06-25 17:37:53'), (82, '李四', 1, 1, '0003', '0005', '0009', '李四', '17982377127', '17982377127', '330683', '陕西省延安市志丹县', '2018-06-25 16:02:55'), (83, '周八', 1, 1, '0003', '0008', '0009', '周八', '13125149830', '13125149830', '130822', '黑龙江省双鸭山市集贤县', '2018-06-25 16:29:33'), (84, '王五', 1, 1, '0003', '0007', '0010', '王五', '15298663573', '15298663573', '342625', '黑龙江省佳木斯市东风区', '2018-06-25 15:01:19'), (85, '郑十', 1, 1, '0003', '0008', '0010', '郑十', '18522240450', '18522240450', '654121', '安徽省池州地区青阳县', '2018-06-25 13:41:16'), (86, '周八', 1, 1, '0003', '0005', '0010', '周八', '17812387376', '17812387376', '511501', '河北省沧州市新华区', '2018-06-25 17:13:54'), (87, '刘一', 1, 1, '0001', '0007', '0010', '刘一', '18402558654', '18402558654', '500000', '山西省晋城市城区', '2018-06-25 18:40:38'), (88, '吴九', 1, 1, '0003', '0005', '0009', '吴九', '13040952694', '13040952694', '620525', '海南省三亚市万宁市', '2018-06-25 18:18:14'), (89, '王五', 1, 1, '0003', '0005', '0009', '王五', '17682383913', '17682383913', '460102', '安徽省蚌埠市固镇县', '2018-06-25 19:13:57'), (90, '郑十', 1, 1, '0002', '0005', '0010', '郑十', '13760665796', '13760665796', '370305', '山西省临汾地区隰县', '2018-06-25 12:10:51'), (91, '陈二', 1, 1, '0001', '0008', '0010', '陈二', '13860605311', '13860605311', '513321', '河南省南阳市内乡县', '2018-06-25 19:14:57'), (92, '李四', 1, 1, '0002', '0008', '0010', '李四', '18169026261', '18169026261', '140201', '河南省驻马店地区新蔡县', '2018-06-25 14:22:47'), (93, '张三', 1, 1, '0004', '0005', '0009', '张三', '17081774997', '17081774997', '612725', '内蒙古自治区乌兰察布盟集宁市', '2018-06-25 16:23:33'), (94, '张三', 1, 1, '0002', '0008', '0009', '张三', '13657905892', '13657905892', '140430', '云南省曲靖市罗平县', '2018-06-25 16:03:26'), (95, '孙七', 1, 1, '0004', '0007', '0009', '孙七', '15903489173', '15903489173', '610404', '湖南省衡阳市衡南县', '2018-06-25 16:29:09'), (96, '郑十', 1, 1, '0004', '0008', '0010', '郑十', '15001987810', '15001987810', '211200', '广东省阳江市阳西县', '2018-06-25 14:58:55'), (97, '刘一', 1, 1, '0003', '0007', '0010', '刘一', '13910578486', '13910578486', '441701', '陕西省渭南市临渭区', '2018-06-25 13:23:54'), (98, '李四', 1, 1, '0003', '0007', '0009', '李四', '17611700623', '17611700623', '500106', '湖南省湘西土家族苗族自治州保靖县', '2018-06-25 19:19:26'), (99, '吴九', 1, 1, '0001', '0007', '0009', '吴九', '18588661421', '18588661421', '332528', '甘肃省武威地区天祝藏族自治县', '2018-06-25 13:27:10'), (100, '陈二', 1, 1, '0004', '0007', '0010', '陈二', '17450268640', '17450268640', '610425', '西藏自治区日喀则地区康马县', '2018-06-25 18:20:52');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `user_id` int(32) NOT NULL AUTO_INCREMENT,
  `user_code` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户账号',
  `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名称',
  `user_password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户密码',
  `user_state` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '1' COMMENT '用户状态(1:正常,0:暂停)',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'm0001', '小张', '111', '1'), (2, 'm0002', '啧啧啧', '111111', '1'), (4, 'sss', 's', 'ssssss', '1'), (6, 'aaa', '啊实打实大', 'aaaaaa', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
